iMIS Analytics comprises some program files, OLAP database components, and a briefing book designed for the third-party product ProClarity Professional. The OLAP database components can be installed to the same SQL Server host that contains your iMIS database (a single-tier configuration), or they can be installed to a separate SQL Server host (a two-tier configuration).
■ The server host on which the Analytics program is installed is the iMIS application server (appserver).
■ The SQL Server host on which the OLAP database components reside is the Analytics host.
■ The SQL Server host on which the iMIS database resides is the iMIS host.
■ If you installed the OLAP database components on the same host as the iMIS database, the Analytics host is also the iMIS host.
Analytics is installed as an optional component by performing a Custom installation with the iMIS installer on an application server host.
iMIS application server requirements
■ iMIS application server hosts must meet all stated application server requirements for iMIS.
■ The database server host that contains the SQL Server instance in which you want to create your Analytics data warehouse and analysis database must also have a default instance of SQL Server installed on it, and that default instance must have Microsoft SQL Server Integration Services (SSIS) installed. This is required by the Integration Services packages used by Analytics.
■ ProClarity Professional (version must support SQL Server Analysis Services)
Caution! Install ProClarity Professional on the iMIS application server before installing Analytics. If it is not present on the appserver when you install Analytics, the Briefing Book will be missing connection information.
■ For best results, use the same versions of Windows Server and SQL Server on both the iMIS and Analytics host servers. If you must combine 32-bit and 64-bit servers and/or 2005 and 2008 versions of SQL Server, ensure that your iMIS host has version of SQL Tools that matches that of your Analytics host:
|
iMIS Host |
Analytics Host |
Compatibility requirement |
|
32-bit + SQL 2005 |
64-bit + SQL 2005 |
No issues. |
|
32-bit + SQL 2005 |
32-bit + SQL 2008 |
Install SQL 2008 Tools and integration services on the iMIS host. |
|
32-bit + SQL 2005 |
64-bit + SQL 2008 |
Install Analytics from the 64-bit host (32-bit cannot remotely configure 64-bit). |
|
64-bit + SQL 2008 |
32-bit + SQL 2005 |
Install SQL 2005 Tools on the iMIS host. |
|
64-bit + SQL 2008 |
32-bit + SQL 2008 |
No issues. |
|
64-bit + SQL 2008 |
64-bit + SQL 2005 |
Install SQL 2005 Tools on the iMIS host. |
Analytics host system requirements
■ The Analytics host must meet all database server requirements for iMIS, as well as these more specific requirements:
□ 10/100 Mbps network speed (or faster) connection to all related iMIS application server hosts and to all client computers that are running ProClarity Professional
□ Microsoft SQL Server (non-Express Edition version only)
□ Microsoft Analysis Services, which must be installed in the default location: C:\Program Files\Microsoft Analysis Services
□ Microsoft SQL Server Business Intelligence Development Studio
□ The database server host that contains the SQL Server instance in which you want to create your Analytics data warehouse and analysis database must also have a default instance of SQL Server installed on it, and that default instance must have Microsoft SQL Server Integration Services (SSIS) installed. This is required by the Integration Services packages used by Analytics.
□ If Analytics is installed on a separate database server host from the iMIS database server host, both hosts must be members of the same Windows domain, and both hosts must be configured to allow network DTC access (see Enabling network DTC access for multi-server configurations). This is required by the Integration Services packages used by Analytics.
iMIS host system requirements
■ The iMIS host must meet all stated database server requirements for iMIS.
■ The iMIS database must contain the license key for Analytics.
Workstation requirements
■ OLAP viewer software; ProClarity Professional recommended.
Although you can use any OLAP viewer to browse the Analytics cubes, the Analytics Briefing Book is designed to work with ProClarity Desktop Professional. The Analytics Briefing Book contains many useful predefined views to help you analyze your iMIS business performance.
■ Processor speed, memory, and disk space sufficient to meet the requirements for ProClarity Professional
■ Workstations running ProClarity Professional must be able to address the Analytics host by using a standard Windows domain computer name
Note: Using ProClarity Professional on a remotely-accessed Terminal Server or Citrix machine is untested.
Note: VPN connections from ProClarity Professional on a workstation to the domain containing the Analytics host is untested.